Subtotals
If you use a sort order to create break groups within the report, you can calculate the subtotal for each break group. See "Sorting records" section for information about sorting with break groups.”
For example, a report that is sorted in ascending order by Cust-Num and descending order by Order-Num, contains two break groups: one for customers and one for orders. You can use either the break group associated with Cust-Num or the break group associated with Order-Num to create subtotals.
Figure 6–12 shows a report that contains a subtotal associated with the Order-Num break group to calculate the total price for all the items in each order.
The report presented in Figure 6–13 contains an additional subtotal based on the Cust-Num break group to calculate the total price of all the items each customer ordered. This subtotal includes all the items in all the orders for each customer.
As shown in this example, you can use any combination of subtotals for each break group.
You can create an aggregate field based on any database field and on the following types of calculated fields: Math, String Function, Numeric function, Date Function, and Logical Function.